package com.lhy.service;


import java.sql.Timestamp;
import java.util.List;

import com.lhy.domain.ApplyMsg;
import com.lhy.domain.Chat;
import com.lhy.domain.ChatTea;
import com.lhy.domain.Friend;
import com.lhy.domain.NewMessage;
import com.lhy.domain.ShopCart;
import com.lhy.domain.Student;
import com.lhy.domain.Tea;

public interface IUserService {
	public Student selectByUserNameANDUserpwd(String username, String password);
	public void insert(Student u);
	public Student queryStudentBySequence(Integer sequence);
	public void saveChatTeaContent(Integer valueOf, String nickname,String content);
	public List<ChatTea> queryAllChatTea();
	public List<Tea> selectTeas();
	public Tea queryTeaByteaId(Integer teaId);
	public Integer queryAllChatTeaCount();
	public List<ChatTea> queryChatTeaBypage(Integer startIndex, Integer endIndex);
	public void insertShoppingCart(Integer sequence, Integer teaId, String teaname, String teaimg, String url, Integer shopcartId);
	public Integer queryAllShopCartCountBysequence(Integer sequence);
	public List<ShopCart> queryShopCartBySequencepage(Integer sequence,
			Integer startIndex, Integer endIndex);
	public void removeShopCart(Integer sequence, Integer shopcartId);
	public Tea queryTeaByteaname(String teaname);
	public Student selectByUserName(String username);
	public void deleteOverdueChatTea();
	public Integer queryAllFriendCount(Integer sequence);
	public List<Friend> queryAllFriend(Integer sequence);
	public Integer queryAllUserCountDeleteFriends(Integer sequence,
			Integer[] friendSequences);
	public List<Student> queryAllUserByPageDeleteFriends(
			Integer sequence, Integer[] friendSequences, Integer startIndex,
			Integer endIndex);
	public Integer queryAllUserCount(Integer sequence);
	public List<Student> queryAllUserByPage(Integer sequence,
			Integer startIndex, Integer endIndex);
	public Student queryStudentByUsername(String username);
	public void findFriendApply(Integer valueOf, Integer userSequence,
			Integer userid, String nickname, String email, String phonenumber,
			String remark, String message, Timestamp create_dt, String sex,
			Integer state, String img);
	public Integer queryCountByUsername(String username);
	public Integer selectCountByApplyMsg(Integer sequence);
	public List<ApplyMsg> selectApplyMsgByUsersequenceAndPage(Integer sequence,
			Integer startIndex, Integer endIndex);
	public ApplyMsg selectApplyMsgByUsersequenceAndMsgsequence(Integer valueOf,
			Integer valueOf2);
	public void insertFriend(Integer valueOf, Integer sequence, Integer userid,
			String nickname, String remark, String sex, String email,
			String phonenumber, String img);
	public void createChatTableBySequence(Integer sequence, Integer valueOf);
	public void deleteFriendApplyBySequence(Integer valueOf, Integer valueOf2);
	public List<Friend> queryAllFriendByPage(Integer sequence,
			Integer startIndex, Integer endIndex);
	public void deleteFriend(Integer valueOf, Integer valueOf2);
	public void deleteChatTable(Integer valueOf, Integer valueOf2);
	public List<Chat> queryMessageBySequence(Integer seQuence,
			Integer userSequence);
	public void insertChatMessage(Integer count2, Integer count1,
			Integer userSequence, Integer seQuence, String nickname,
			String remark, Timestamp create_dt, String message);
	public NewMessage queryNewMessageById(Integer valueOf);
	public void insertNewMessageByClob(String author, String title,
			String content, Timestamp create_dt, Integer sequence,
			Integer valueOf);
	public Integer queryAllNewMessageCount();
	public List<NewMessage> queryAllNewMessageByPage(Integer startIndex,
			Integer endIndex);
	public List<NewMessage> queryNewMessageList();
	public List<NewMessage> queryNewMessageListByPd(String author,
			String title, String startTime, String endTime);
	public void deleteNewMessageByPd(Integer valueOf);
	public void updateNewMessage(String author, String title, String content,
			Timestamp create_dt, Integer valueOf);
}
